SherbyNet - /page/wikibook/entry.mu

Micron Document

<!DOCTYPE html>

<title>Module SQL</title>

</head>

<span id="openzim-page-title" class="mw-page-title-main"><span class="mw-page-title-main">Module SQL</span></span>

</h1>

</header>

<p><b>Module SQL</b> is a method of combining the <a href="Computing" title="Computing">computing</a> power of a <a href="Programming_language" title="Programming language">programming language</a> and the <a href="Database" title="Database">database</a> <a href="Data_Manipulation_Language" class="mw-redirect" title="Data Manipulation Language">manipulation</a> capabilities of <a href="SQL" title="SQL">SQL</a>. Module SQL <a href="Statement_(programming)" class="mw-redirect" title="Statement (programming)">statements</a> are SQL statements written in an SQL client module, that can be called as routines from the host language program <a href="Source_code" title="Source code">source code</a> like a host language routine. An SQL standard Module Language file is <a href="Compiler" title="Compiler">compiled</a> into calls to a SQL <a href="Runtime_library" title="Runtime library">runtime library</a> that interacts with the <a href="DBMS" class="mw-redirect" title="DBMS">Database management system</a>. This allows programmers to call SQL statements from applications written in regular programming languages.

</p><p>Using Module Language is very straightforward: place all SQL code in a separate module, and define an interface between the module containing the SQL code and the host program.<sup id="cite_ref-modulelang_1-0" class="reference"><a href="#cite_note-modulelang-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup>

</p><p>Module SQL is closely related to <a href="Embedded_SQL" title="Embedded SQL">Embedded SQL</a>. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<sup id="cite_ref-2" class="reference"><a href="#cite_note-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading2"><h2 id="SQL_Standard_Compliance">SQL Standard Compliance</h2></div>

<p>The <a href="SQL%3A2023" title="SQL:2023">SQL:2023</a> standard (ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation), chapter 13<sup id="cite_ref-3" class="reference"><a href="#cite_note-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup>) defines an SQL module as an <i>SQL client module</i>, and the language in which SQL queries are called is referred to as the <i>host language</i>. Specified host languages are:

</p>

<ul><li><a href="Ada_(programming_language)" title="Ada (programming language)">Ada</a> - Feature B111, “Module language Ada”</li>

<li><a href="C_(programming_language)" title="C (programming language)">C</a> - Feature B112, “Module language C”</li>

<li><a href="COBOL" title="COBOL">COBOL</a> - Feature B113, “Module language COBOL”</li>

<li><a href="Fortran" title="Fortran">Fortran</a> - Feature B114, “Module language Fortran”</li>

<li><a href="MUMPS" title="MUMPS">MUMPS</a> - Feature B115, “Module language MUMPS”</li>

<li><a href="Pascal_(programming_language)" title="Pascal (programming language)">Pascal</a> - Feature B116, “Module language Pascal”</li>

<li><a href="PL/I" title="PL/I">PL/I</a> - Feature B117, “Module language PL/I”</li></ul>

<p>(All the languages listed above are optional features, which means that each vendor can decide which language(s) to support.)

</p>

<div class="mw-heading mw-heading2"><h2 id="Database_systems_that_support_module_SQL">Database systems that support module SQL</h2></div>

<div class="mw-heading mw-heading3"><h3 id="Mimer_SQL"><a href="Mimer_SQL" title="Mimer SQL">Mimer SQL</a></h3></div>

<p>Mimer SQL 11.0 and later for <a href="Linux" title="Linux">Linux</a>, <a href="MacOS" title="MacOS">macOS</a>, <a href="OpenVMS" title="OpenVMS">OpenVMS</a> and <a href="Windows" class="mw-redirect" title="Windows">Windows</a> support module SQL for C/C++, and Mimer SQL for <a href="OpenVMS" title="OpenVMS">OpenVMS</a> also supports module SQL for COBOL, Fortran and Pascal.<sup id="cite_ref-4" class="reference"><a href="#cite_note-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading3"><h3 id="Oracle_Database"><a href="Oracle_Database" title="Oracle Database">Oracle Database</a></h3></div>

<p>Oracle 8.0 supported SQL*Module for Ada but support has been removed in later versions.<sup id="cite_ref-5" class="reference"><a href="#cite_note-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> SQL*Module is a module language that supports the Ada83 language standard for Ada.<sup id="cite_ref-6" class="reference"><a href="#cite_note-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading3"><h3 id="Oracle_Rdb"><a href="Oracle_Rdb" title="Oracle Rdb">Oracle Rdb</a></h3></div>

<p>Supported host languages are Ada, <a href="BASIC" title="BASIC">BASIC</a>, C, COBOL, Fortran, Pascal and PL/I.<sup id="cite_ref-7" class="reference"><a href="#cite_note-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}

/* end https://en.wikipedia.org/ */

</style><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/ch1.htm#2889">"The Module Language Concept"</a>. <i>SQL*Module for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQL*Module</i>. <a href="Oracle_Corporation" title="Oracle Corporation">Oracle Corporation</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2023-03-30</span></span>.</cite></span>

</li>

<li id="cite_note-2"><span class="mw-cite-backlink"><b><a href="#cite_ref-2">^</a></b></span> <span class="reference-text"><cite id="CITEREFOppel2015" class="citation book cs1">Oppel, Andrew (November 2015). <a rel="nofollow" class="external text" href="https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules"><i>SQL: A Beginner's Guide, Fourth Edition, 4th Edition</i></a> (4th ed.). McGraw-Hill. p. 544. <a href="ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a> <bdi>978-0071842594</bdi>.</cite></span>

</li>

<li id="cite_note-3"><span class="mw-cite-backlink"><b><a href="#cite_ref-3">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://www.iso.org/standard/76584.html">"SQL Standard 2023, Chapter 13 SQL-client modules"</a>. <i>ISO/IEC 9075-2:2023 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)</i>. <a href="ISO" class="mw-redirect" title="ISO">ISO</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2023-06-05</span></span>.</cite></span>

</li>

<li id="cite_note-4"><span class="mw-cite-backlink"><b><a href="#cite_ref-4">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm">"Module SQL"</a>. <i>Mimer SQL Programmer's Manual latest version, Module SQL</i>. <a href="Mimer_SQL" title="Mimer SQL">Mimer SQL</a>.</cite></span>

</li>

<li id="cite_note-5"><span class="mw-cite-backlink"><b><a href="#cite_ref-5">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf">"SQL*Module™ for Ada - Programmer's Guide"</a> <span class="cs1-format">(PDF)</span>. Oracle Corporation<span class="reference-accessdate">. Retrieved <span class="nowrap">2023-06-19</span></span>.</cite></span>

</li>

<li id="cite_note-6"><span class="mw-cite-backlink"><b><a href="#cite_ref-6">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868">"Ada Support in Version 8"</a>. <i>Oracle9i Database Migration, Release 2 (9.2), Chapter 5. Compatibility and Interoperability</i>. Oracle Corporation<span class="reference-accessdate">. Retrieved <span class="nowrap">2023-03-30</span></span>.</cite></span>

</li>

<li id="cite_note-7"><span class="mw-cite-backlink"><b><a href="#cite_ref-7">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://download.oracle.com/otn_hosted_doc/rdb/pdf/gsp.pdf">"Oracle Rdb7™, Guide to SQL Programming"</a> <span class="cs1-format">(PDF)</span>. Oracle Corporation<span class="reference-accessdate">. Retrieved <span class="nowrap">2023-06-05</span></span>.</cite></span>

</li>

</ol></div>

<div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2></div>

<ul><li><a rel="nofollow" class="external text" href="https://docs.oracle.com/cd/B10501_01/appdev.920/a58231/ch2.htm">SQL*Module for Ada Programmer's Guide, Release 8.0</a></li>

<li><a rel="nofollow" class="external text" href="https://developer.mimer.com/article/module-sql/">Module SQL, Mimer SQL Developer</a></li></ul></div><div><div class="zim-footer">

This article is issued from <a class="external text" title="Last edited on 2025-04-20" href="https://en.wikipedia.org/wiki/?title=Module_SQL&oldid=1286463446">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.

</div>

</div></div>

</div>

</main>

</div>

</body></html>